LOAD DATA
TRUNCATE 
INTO TABLE gex_bde_amt_pgp_tb
TRAILING NULLCOLS 
(line_no                SEQUENCE(MAX)
,date_eff		POSITION(1:11)		"TO_DATE(:date_eff,'YYYY/MM/DD')"                      
,entite			POSITION(12:26)		CHAR 
,div			POSITION(27:31) 	CHAR
,act			POSITION(32:36) 	CHAR    
,gest			POSITION(37:42)		CHAR
,cl 			POSITION(43:47) 	CHAR
,frequence		POSITION(48:57)		CHAR
,categ			POSITION(58:63)		CHAR
,geo 			POSITION(64:68)		CHAR
,type 			POSITION(69:73)		CHAR
,type_montant 		POSITION(74:86)		CHAR
,montant 		POSITION(87:105)	"TO_NUMBER(:montant,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,unites 		POSITION(106:126)	"TO_NUMBER(:unites,'99999999999999D99','NLS_NUMERIC_CHARACTERS=''. ''')"
,provenance 		POSITION(127:136)	CHAR
)                                                                                                      
